package backstage.app.mapper;

 

import java.util.List;

import org.springframework.stereotype.Repository;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import backstage.app.entity.AllStudent;
import backstage.app.entity.Student;
import backstage.app.entity.StudentEcharts;
 
@Repository
public interface StudentMapper extends BaseMapper<Student>{
     
    int deleteByPrimaryKey(Integer sid);
    
    AllStudent selectAllStudent();
   
    /**统计最新30条数据*/
     List<StudentEcharts> selectEchartsList();
    
    int insertSelective(Student student);

    Integer selectByPrimaryKeyCountType(Integer studentType);

    Student selectByPrimaryKey(Integer sid);
 
    List<Student> selectlimitAndWhere(String name,Integer studentType,Integer page,Integer limit);
    List<Student>selectlimitAndWhereHaveName(String name,Integer page,Integer limit);
    List<Student> selectlimitAndWhereNotType(Integer page,Integer limit);
    
    int updateByPrimaryKey(Student student);
}